dataSource {
    pooled = true
    /*driverClassName = "org.hsqldb.jdbcDriver"
    username = "sa"
    password = ""*/
	driverClassName = "org.postgresql.Driver"
	//dialect = "org.hibernate.dialect.PostgreSQLDialect"
	dialect = "ecitys.util.EcitysPostgresSqlDialect"
	username = "postgres"
	password = "postgres"
}

hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = true
    cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'
}
// environment specific settings
environments {
    development {
        dataSource {
            dbCreate = "update" // one of 'create', 'create-drop','update'
            //url = "jdbc:hsqldb:mem:devDB"
			url = "jdbc:postgresql://localhost:5432/ecityDev"
        }
    }
    test {
        dataSource {
            dbCreate = "update"
            //url = "jdbc:hsqldb:mem:testDb"
			url = "jdbc:postgresql://localhost:5432/ecityTest"
        }
    }
    production {
        dataSource {
            dbCreate = "update"
            //url = "jdbc:hsqldb:file:prodDb;shutdown=true"
			url = "jdbc:postgresql://localhost:5432/ecityProd"
        }
    }
}
